Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 822 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 183.2 KiB |
| Average record size in memory | 228.2 B |
Variable types
| Categorical | 5 |
|---|---|
| Numeric | 11 |
Dataset
| Description | Este es un analisis preeliminar para comprender de mejor forma los datos de nuestro dataset |
|---|---|
| Author | Kenneth David Leonel Triana , Juan Jose Naranjo, Alejandro Mora |
| URL | https://github.com/kennethLeonel/Monografia-calidad-del-aire-valle-de-aburra |
anio has constant value "2024" | Constant |
festivo is highly imbalanced (72.5%) | Imbalance |
pm25 is highly skewed (γ1 = 28.62792907) | Skewed |
codigoserial is uniformly distributed | Uniform |
dia_semana is uniformly distributed | Uniform |
estacion is uniformly distributed | Uniform |
presion has 225 (27.4%) zeros | Zeros |
p1 has 213 (25.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-10-16 21:17:35.613046 |
|---|---|
| Analysis finished | 2024-10-16 21:17:46.142169 |
| Duration | 10.53 seconds |
| Software version | ydata-profiling vv4.11.0 |
| Download configuration | config.json |
Variables
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024 |
|---|---|
| 2nd row | 2024 |
| 3rd row | 2024 |
| 4th row | 2024 |
| 5th row | 2024 |
Common Values
| Value | Count | Frequency (%) |
| 2024 | 822 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024 | 822 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1644 | |
| 0 | 822 | |
| 4 | 822 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3288 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1644 | |
| 0 | 822 | |
| 4 | 822 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3288 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1644 | |
| 0 | 822 | |
| 4 | 822 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3288 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1644 | |
| 0 | 822 | |
| 4 | 822 |
mes
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0072993 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 9 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.5816641 |
|---|---|
| Coefficient of variation (CV) | 0.51558014 |
| Kurtosis | -1.2270774 |
| Mean | 5.0072993 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.010631573 |
| Sum | 4116 |
| Variance | 6.6649893 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 1 | 93 | |
| 3 | 93 | |
| 5 | 93 | |
| 7 | 93 | |
| 8 | 93 | |
| 4 | 90 | |
| 6 | 90 | |
| 9 | 90 | |
| 2 | 87 |
| Value | Count | Frequency (%) |
| 1 | 93 | |
| 2 | 87 | |
| 3 | 93 | |
| 4 | 90 | |
| 5 | 93 | |
| 6 | 90 | |
| 7 | 93 | |
| 8 | 93 | |
| 9 | 90 |
| Value | Count | Frequency (%) |
| 9 | 90 | |
| 8 | 93 | |
| 7 | 93 | |
| 6 | 90 | |
| 5 | 93 | |
| 4 | 90 | |
| 3 | 93 | |
| 2 | 87 | |
| 1 | 93 |
dia
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.729927 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.8023391 |
|---|---|
| Coefficient of variation (CV) | 0.55959186 |
| Kurtosis | -1.1958321 |
| Mean | 15.729927 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0050555266 |
| Sum | 12930 |
| Variance | 77.481174 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 1 | 27 | 3.3% |
| 2 | 27 | 3.3% |
| 29 | 27 | 3.3% |
| 28 | 27 | 3.3% |
| 27 | 27 | 3.3% |
| 26 | 27 | 3.3% |
| 25 | 27 | 3.3% |
| 24 | 27 | 3.3% |
| 23 | 27 | 3.3% |
| 22 | 27 | 3.3% |
| Other values (21) | 552 |
| Value | Count | Frequency (%) |
| 1 | 27 | |
| 2 | 27 | |
| 3 | 27 | |
| 4 | 27 | |
| 5 | 27 | |
| 6 | 27 | |
| 7 | 27 | |
| 8 | 27 | |
| 9 | 27 | |
| 10 | 27 |
| Value | Count | Frequency (%) |
| 31 | 15 | |
| 30 | 24 | |
| 29 | 27 | |
| 28 | 27 | |
| 27 | 27 | |
| 26 | 27 | |
| 25 | 27 | |
| 24 | 27 | |
| 23 | 27 | |
| 22 | 27 |
pm25
Real number (ℝ)
Skewed
| Distinct | 778 |
|---|---|
| Distinct (%) | 94.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5655.2644 |
| Minimum | -9999 |
|---|---|
| Maximum | 4216635.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 63 |
| Negative (%) | 7.7% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | -405.4405 |
| Q1 | 14.321539 |
| median | 19.186874 |
| Q3 | 26.958333 |
| 95-th percentile | 4179.338 |
| Maximum | 4216635.3 |
| Range | 4226634.3 |
| Interquartile range (IQR) | 12.636794 |
Descriptive statistics
| Standard deviation | 147127.23 |
|---|---|
| Coefficient of variation (CV) | 26.015978 |
| Kurtosis | 820.3519 |
| Mean | 5655.2644 |
| Median Absolute Deviation (MAD) | 5.7285406 |
| Skewness | 28.627929 |
| Sum | 4648627.4 |
| Variance | 2.1646423 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24.5 | 3 | 0.4% |
| 13.45833333 | 3 | 0.4% |
| 18.08333333 | 3 | 0.4% |
| 16.625 | 3 | 0.4% |
| 19.70833333 | 3 | 0.4% |
| 17.45833333 | 3 | 0.4% |
| 15.54166667 | 2 | 0.2% |
| 20.41666667 | 2 | 0.2% |
| 28.875 | 2 | 0.2% |
| 13.25 | 2 | 0.2% |
| Other values (768) | 796 |
| Value | Count | Frequency (%) |
| -9999 | 1 | |
| -5823.583333 | 1 | |
| -5407.477219 | 1 | |
| -4575.428069 | 1 | |
| -4160.207614 | 1 | |
| -4155.650887 | 1 | |
| -4153.013067 | 1 | |
| -2487.168203 | 1 | |
| -2480.750017 | 1 | |
| -2067.635837 | 1 |
| Value | Count | Frequency (%) |
| 4216635.281 | 1 | |
| 99999 | 1 | |
| 45840.1535 | 1 | |
| 41671.96746 | 1 | |
| 32093.08017 | 1 | |
| 20846.47932 | 1 | |
| 16692.34784 | 1 | |
| 16679.97371 | 1 | |
| 16677.98897 | 1 | |
| 16677.89734 | 1 |
codigoserial
Categorical
Uniform
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.4 KiB |
| 28 | |
|---|---|
| 69 | |
| 86 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 28 |
|---|---|
| 2nd row | 28 |
| 3rd row | 28 |
| 4th row | 28 |
| 5th row | 28 |
Common Values
| Value | Count | Frequency (%) |
| 28 | 274 | |
| 69 | 274 | |
| 86 | 274 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 28 | 274 | |
| 69 | 274 | |
| 86 | 274 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8 | 548 | |
| 6 | 548 | |
| 2 | 274 | |
| 9 | 274 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1644 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 8 | 548 | |
| 6 | 548 | |
| 2 | 274 | |
| 9 | 274 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1644 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 8 | 548 | |
| 6 | 548 | |
| 2 | 274 | |
| 9 | 274 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1644 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 8 | 548 | |
| 6 | 548 | |
| 2 | 274 | |
| 9 | 274 |
dia_semana
Categorical
Uniform
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.0 KiB |
| Lunes | |
|---|---|
| Martes | |
| Miercoles | |
| Jueves | |
| Viernes | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.5656934 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Lunes |
|---|---|
| 2nd row | Martes |
| 3rd row | Miercoles |
| 4th row | Jueves |
| 5th row | Viernes |
Common Values
| Value | Count | Frequency (%) |
| Lunes | 120 | |
| Martes | 117 | |
| Miercoles | 117 | |
| Jueves | 117 | |
| Viernes | 117 | |
| Sabado | 117 | |
| Domingo | 117 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lunes | 120 | |
| martes | 117 | |
| miercoles | 117 | |
| jueves | 117 | |
| viernes | 117 | |
| sabado | 117 | |
| domingo | 117 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 939 | |
| s | 588 | |
| o | 468 | 8.7% |
| n | 354 | 6.6% |
| i | 351 | 6.5% |
| a | 351 | 6.5% |
| r | 351 | 6.5% |
| u | 237 | 4.4% |
| M | 234 | 4.3% |
| L | 120 | 2.2% |
| Other values (12) | 1404 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5397 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 939 | |
| s | 588 | |
| o | 468 | 8.7% |
| n | 354 | 6.6% |
| i | 351 | 6.5% |
| a | 351 | 6.5% |
| r | 351 | 6.5% |
| u | 237 | 4.4% |
| M | 234 | 4.3% |
| L | 120 | 2.2% |
| Other values (12) | 1404 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5397 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 939 | |
| s | 588 | |
| o | 468 | 8.7% |
| n | 354 | 6.6% |
| i | 351 | 6.5% |
| a | 351 | 6.5% |
| r | 351 | 6.5% |
| u | 237 | 4.4% |
| M | 234 | 4.3% |
| L | 120 | 2.2% |
| Other values (12) | 1404 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5397 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 939 | |
| s | 588 | |
| o | 468 | 8.7% |
| n | 354 | 6.6% |
| i | 351 | 6.5% |
| a | 351 | 6.5% |
| r | 351 | 6.5% |
| u | 237 | 4.4% |
| M | 234 | 4.3% |
| L | 120 | 2.2% |
| Other values (12) | 1404 |
estacion
Categorical
Uniform
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 58.3 KiB |
| Estacion Itagui | |
|---|---|
| Estacion Caldas | |
| Estacion Aranjuez |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 15.666667 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Estacion Itagui |
|---|---|
| 2nd row | Estacion Itagui |
| 3rd row | Estacion Itagui |
| 4th row | Estacion Itagui |
| 5th row | Estacion Itagui |
Common Values
| Value | Count | Frequency (%) |
| Estacion Itagui | 274 | |
| Estacion Caldas | 274 | |
| Estacion Aranjuez | 274 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| estacion | 822 | |
| itagui | 274 | 16.7% |
| caldas | 274 | 16.7% |
| aranjuez | 274 | 16.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1918 | |
| t | 1096 | 8.5% |
| i | 1096 | 8.5% |
| n | 1096 | 8.5% |
| s | 1096 | 8.5% |
| E | 822 | 6.4% |
| c | 822 | 6.4% |
| o | 822 | 6.4% |
| 822 | 6.4% | |
| u | 548 | 4.3% |
| Other values (10) | 2740 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12878 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1918 | |
| t | 1096 | 8.5% |
| i | 1096 | 8.5% |
| n | 1096 | 8.5% |
| s | 1096 | 8.5% |
| E | 822 | 6.4% |
| c | 822 | 6.4% |
| o | 822 | 6.4% |
| 822 | 6.4% | |
| u | 548 | 4.3% |
| Other values (10) | 2740 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12878 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1918 | |
| t | 1096 | 8.5% |
| i | 1096 | 8.5% |
| n | 1096 | 8.5% |
| s | 1096 | 8.5% |
| E | 822 | 6.4% |
| c | 822 | 6.4% |
| o | 822 | 6.4% |
| 822 | 6.4% | |
| u | 548 | 4.3% |
| Other values (10) | 2740 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12878 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1918 | |
| t | 1096 | 8.5% |
| i | 1096 | 8.5% |
| n | 1096 | 8.5% |
| s | 1096 | 8.5% |
| E | 822 | 6.4% |
| c | 822 | 6.4% |
| o | 822 | 6.4% |
| 822 | 6.4% | |
| u | 548 | 4.3% |
| Other values (10) | 2740 |
festivo
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.6 KiB |
| 0 | |
|---|---|
| 1 | 39 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 783 | |
| 1 | 39 | 4.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 783 | |
| 1 | 39 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 783 | |
| 1 | 39 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 822 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 783 | |
| 1 | 39 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 822 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 783 | |
| 1 | 39 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 822 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 783 | |
| 1 | 39 | 4.7% |
temperatura
Real number (ℝ)
| Distinct | 748 |
|---|---|
| Distinct (%) | 91.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -74.234121 |
| Minimum | -999 |
|---|---|
| Maximum | 25.805556 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 88 |
| Negative (%) | 10.7% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 19.824358 |
| median | 21.754094 |
| Q3 | 23.441821 |
| 95-th percentile | 24.64388 |
| Maximum | 25.805556 |
| Range | 1024.8056 |
| Interquartile range (IQR) | 3.6174635 |
Descriptive statistics
| Standard deviation | 292.08232 |
|---|---|
| Coefficient of variation (CV) | -3.9346101 |
| Kurtosis | 5.9065192 |
| Mean | -74.234121 |
| Median Absolute Deviation (MAD) | 1.7726007 |
| Skewness | -2.7890436 |
| Sum | -61020.447 |
| Variance | 85312.081 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -999 | 70 | 8.5% |
| 19.81208333 | 2 | 0.2% |
| 18.25715278 | 2 | 0.2% |
| 22.61555556 | 2 | 0.2% |
| 23.85430556 | 2 | 0.2% |
| 21.50506944 | 2 | 0.2% |
| 19.76848613 | 1 | 0.1% |
| 24.60888889 | 1 | 0.1% |
| 23.99152778 | 1 | 0.1% |
| 24.12041667 | 1 | 0.1% |
| Other values (738) | 738 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -973.3485417 | 1 | 0.1% |
| -967.7763889 | 1 | 0.1% |
| -583.7022014 | 1 | 0.1% |
| -577.5151389 | 1 | 0.1% |
| -577.2209722 | 1 | 0.1% |
| -494.8014722 | 1 | 0.1% |
| -490.0909028 | 1 | 0.1% |
| -487.1159722 | 1 | 0.1% |
| -486.8761111 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 25.80555556 | 1 | |
| 25.60798611 | 1 | |
| 25.60576389 | 1 | |
| 25.52388889 | 1 | |
| 25.51756944 | 1 | |
| 25.50707636 | 1 | |
| 25.49993056 | 1 | |
| 25.49090278 | 1 | |
| 25.47887501 | 1 | |
| 25.42810416 | 1 |
humedad
Real number (ℝ)
| Distinct | 753 |
|---|---|
| Distinct (%) | 91.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -29.625042 |
| Minimum | -999 |
|---|---|
| Maximum | 88.604813 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 84 |
| Negative (%) | 10.2% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 61.80849 |
| median | 70.541875 |
| Q3 | 76.706493 |
| 95-th percentile | 83.036926 |
| Maximum | 88.604813 |
| Range | 1087.6048 |
| Interquartile range (IQR) | 14.898003 |
Descriptive statistics
| Standard deviation | 306.21792 |
|---|---|
| Coefficient of variation (CV) | -10.336455 |
| Kurtosis | 5.9010952 |
| Mean | -29.625042 |
| Median Absolute Deviation (MAD) | 7.0651042 |
| Skewness | -2.7869321 |
| Sum | -24351.784 |
| Variance | 93769.417 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -999 | 70 | 8.5% |
| 74.87365279 | 1 | 0.1% |
| 65.64958333 | 1 | 0.1% |
| 57.05555556 | 1 | 0.1% |
| 57.02277778 | 1 | 0.1% |
| 58.32020833 | 1 | 0.1% |
| 61.95875 | 1 | 0.1% |
| 56.85229167 | 1 | 0.1% |
| 45.84041667 | 1 | 0.1% |
| 50.73298611 | 1 | 0.1% |
| Other values (743) | 743 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -972.8702778 | 1 | 0.1% |
| -966.1264583 | 1 | 0.1% |
| -568.7318056 | 1 | 0.1% |
| -558.5639375 | 1 | 0.1% |
| -552.68375 | 1 | 0.1% |
| -468.0622222 | 1 | 0.1% |
| -464.3461389 | 1 | 0.1% |
| -457.6452083 | 1 | 0.1% |
| -456.7511111 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 88.60481251 | 1 | |
| 87.52608331 | 1 | |
| 87.07765277 | 1 | |
| 86.09479167 | 1 | |
| 85.533125 | 1 | |
| 85.32188193 | 1 | |
| 85.25628471 | 1 | |
| 85.25097222 | 1 | |
| 85.18998613 | 1 | |
| 85.01345833 | 1 |
presion
Real number (ℝ)
Zeros
| Distinct | 523 |
|---|---|
| Distinct (%) | 63.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 418.34831 |
| Minimum | -999 |
|---|---|
| Maximum | 854.00083 |
| Zeros | 225 |
| Zeros (%) | 27.4% |
| Negative | 97 |
| Negative (%) | 11.8% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 0 |
| median | 825.66128 |
| Q3 | 850.78964 |
| 95-th percentile | 852.63293 |
| Maximum | 854.00083 |
| Range | 1853.0008 |
| Interquartile range (IQR) | 850.78964 |
Descriptive statistics
| Standard deviation | 582.67401 |
|---|---|
| Coefficient of variation (CV) | 1.3927964 |
| Kurtosis | 0.34209453 |
| Mean | 418.34831 |
| Median Absolute Deviation (MAD) | 26.603333 |
| Skewness | -1.1601691 |
| Sum | 343882.31 |
| Variance | 339509 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 225 | |
| -999 | 70 | 8.5% |
| -1.3875 | 3 | 0.4% |
| -0.69375 | 3 | 0.4% |
| -2.08125 | 2 | 0.2% |
| -2.775 | 2 | 0.2% |
| -942.4175694 | 1 | 0.1% |
| 850.4498611 | 1 | 0.1% |
| -77.69125 | 1 | 0.1% |
| -952.7500694 | 1 | 0.1% |
| Other values (513) | 513 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -952.7500694 | 1 | 0.1% |
| -942.4175694 | 1 | 0.1% |
| -592.4625 | 1 | 0.1% |
| -505.74375 | 1 | 0.1% |
| -244.2071528 | 1 | 0.1% |
| -238.9220139 | 1 | 0.1% |
| -81.81826389 | 1 | 0.1% |
| -80.75256944 | 1 | 0.1% |
| -77.69125 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 854.0008333 | 1 | |
| 853.8609028 | 1 | |
| 853.7610417 | 1 | |
| 853.5519444 | 1 | |
| 853.4649306 | 1 | |
| 853.2995139 | 1 | |
| 853.2894444 | 1 | |
| 853.2795833 | 1 | |
| 853.2552778 | 1 | |
| 853.2316667 | 1 |
p1
Real number (ℝ)
Zeros
| Distinct | 275 |
|---|---|
| Distinct (%) | 33.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -107.18585 |
| Minimum | -999 |
|---|---|
| Maximum | 0.064527778 |
| Zeros | 213 |
| Zeros (%) | 25.9% |
| Negative | 161 |
| Negative (%) | 19.6% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 0 |
| median | 6.9444444 × 10-6 |
| Q3 | 0.0033055556 |
| 95-th percentile | 0.023081944 |
| Maximum | 0.064527778 |
| Range | 999.06453 |
| Interquartile range (IQR) | 0.0033055556 |
Descriptive statistics
| Standard deviation | 301.37977 |
|---|---|
| Coefficient of variation (CV) | -2.8117497 |
| Kurtosis | 4.6492889 |
| Mean | -107.18585 |
| Median Absolute Deviation (MAD) | 0.0016944444 |
| Skewness | -2.5524066 |
| Sum | -88106.766 |
| Variance | 90829.766 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 213 | |
| -999 | 79 | 9.6% |
| 6.944444444 × 10-6 | 39 | 4.7% |
| 1.388888889 × 10-5 | 22 | 2.7% |
| 2.083333333 × 10-5 | 14 | 1.7% |
| -0.69375 | 11 | 1.3% |
| 2.777777778 × 10-5 | 8 | 1.0% |
| 7.638888889 × 10-5 | 5 | 0.6% |
| 4.861111111 × 10-5 | 5 | 0.6% |
| 4.166666667 × 10-5 | 5 | 0.6% |
| Other values (265) | 421 |
| Value | Count | Frequency (%) |
| -999 | 79 | |
| -974.025 | 1 | 0.1% |
| -968.475 | 1 | 0.1% |
| -588.3 | 1 | 0.1% |
| -585.525 | 2 | 0.2% |
| -501.58125 | 1 | 0.1% |
| -496.725 | 2 | 0.2% |
| -496.7211181 | 2 | 0.2% |
| -482.1391806 | 2 | 0.2% |
| -359.3587917 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 0.06452777778 | 2 | |
| 0.05119444444 | 2 | |
| 0.04704166667 | 1 | |
| 0.04621527778 | 2 | |
| 0.04209027778 | 2 | |
| 0.03425694444 | 1 | |
| 0.03263888889 | 2 | |
| 0.03171527778 | 2 | |
| 0.03158333333 | 2 | |
| 0.03149305556 | 1 |
velocidad_prom
Real number (ℝ)
| Distinct | 747 |
|---|---|
| Distinct (%) | 90.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -92.735 |
| Minimum | -999 |
|---|---|
| Maximum | 3.4436111 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 121 |
| Negative (%) | 14.7% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 1.1687326 |
| median | 1.5713194 |
| Q3 | 1.8784826 |
| 95-th percentile | 2.4087514 |
| Maximum | 3.4436111 |
| Range | 1002.4436 |
| Interquartile range (IQR) | 0.70975 |
Descriptive statistics
| Standard deviation | 286.22487 |
|---|---|
| Coefficient of variation (CV) | -3.0864815 |
| Kurtosis | 5.9081556 |
| Mean | -92.735 |
| Median Absolute Deviation (MAD) | 0.33965278 |
| Skewness | -2.789423 |
| Sum | -76228.17 |
| Variance | 81924.674 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -999 | 70 | 8.5% |
| 1.664861111 | 2 | 0.2% |
| 1.575694444 | 2 | 0.2% |
| 1.575347222 | 2 | 0.2% |
| 1.612013889 | 2 | 0.2% |
| 1.345277778 | 2 | 0.2% |
| 1.776805556 | 2 | 0.2% |
| 0.8103472222 | 1 | 0.1% |
| 1.363194444 | 1 | 0.1% |
| 1.641388889 | 1 | 0.1% |
| Other values (737) | 737 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -973.9296528 | 1 | 0.1% |
| -968.4334722 | 1 | 0.1% |
| -591.8551181 | 1 | 0.1% |
| -587.5753472 | 1 | 0.1% |
| -584.7041667 | 1 | 0.1% |
| -504.8587361 | 1 | 0.1% |
| -500.8329167 | 1 | 0.1% |
| -496.1823611 | 1 | 0.1% |
| -495.9430556 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 3.443611111 | 1 | |
| 3.122361111 | 1 | |
| 3.081736111 | 1 | |
| 3.025694444 | 1 | |
| 2.898194444 | 1 | |
| 2.753708333 | 1 | |
| 2.744375 | 1 | |
| 2.74 | 1 | |
| 2.687604167 | 1 | |
| 2.671770833 | 1 |
velocidad_max
Real number (ℝ)
| Distinct | 747 |
|---|---|
| Distinct (%) | 90.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -91.80445 |
| Minimum | -999 |
|---|---|
| Maximum | 4.9930556 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 108 |
| Negative (%) | 13.1% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 1.9463889 |
| median | 2.5347917 |
| Q3 | 3.0812153 |
| 95-th percentile | 3.7179167 |
| Maximum | 4.9930556 |
| Range | 1003.9931 |
| Interquartile range (IQR) | 1.1348264 |
Descriptive statistics
| Standard deviation | 286.52051 |
|---|---|
| Coefficient of variation (CV) | -3.1209872 |
| Kurtosis | 5.9079516 |
| Mean | -91.80445 |
| Median Absolute Deviation (MAD) | 0.56944444 |
| Skewness | -2.7893823 |
| Sum | -75463.258 |
| Variance | 82094.004 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -999 | 70 | 8.5% |
| 2.00875 | 2 | 0.2% |
| 2.903611111 | 2 | 0.2% |
| 2.44125 | 2 | 0.2% |
| 2.440069444 | 2 | 0.2% |
| 2.092777778 | 2 | 0.2% |
| 2.534444444 | 2 | 0.2% |
| 0.5947222222 | 1 | 0.1% |
| 4.208819444 | 1 | 0.1% |
| 2.134236111 | 1 | 0.1% |
| Other values (737) | 737 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -973.8575694 | 1 | 0.1% |
| -968.3997917 | 1 | 0.1% |
| -591.5904167 | 1 | 0.1% |
| -586.9434722 | 1 | 0.1% |
| -584.3690972 | 1 | 0.1% |
| -504.4868056 | 1 | 0.1% |
| -500.2472917 | 1 | 0.1% |
| -495.9194444 | 1 | 0.1% |
| -495.5963194 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 4.993055556 | 1 | |
| 4.681458333 | 1 | |
| 4.515555556 | 1 | |
| 4.511180556 | 1 | |
| 4.412986111 | 1 | |
| 4.349027778 | 1 | |
| 4.208819444 | 1 | |
| 4.18 | 1 | |
| 4.162361111 | 1 | |
| 4.134583333 | 1 |
direccion_prom
Real number (ℝ)
| Distinct | 750 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.11877 |
| Minimum | -999 |
|---|---|
| Maximum | 255.27292 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 83 |
| Negative (%) | 10.1% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 131.46059 |
| median | 155.8309 |
| Q3 | 180.85521 |
| 95-th percentile | 208.71969 |
| Maximum | 255.27292 |
| Range | 1254.2729 |
| Interquartile range (IQR) | 49.394618 |
Descriptive statistics
| Standard deviation | 333.19348 |
|---|---|
| Coefficient of variation (CV) | 6.518026 |
| Kurtosis | 5.7516313 |
| Mean | 51.11877 |
| Median Absolute Deviation (MAD) | 25.000347 |
| Skewness | -2.7426624 |
| Sum | 42019.629 |
| Variance | 111017.89 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -999 | 70 | 8.5% |
| 168.2680556 | 2 | 0.2% |
| 142.3944444 | 2 | 0.2% |
| 193.1611111 | 2 | 0.2% |
| 208.6076389 | 1 | 0.1% |
| 146.9715278 | 1 | 0.1% |
| 168.6756944 | 1 | 0.1% |
| 199.6645833 | 1 | 0.1% |
| 137.7208333 | 1 | 0.1% |
| 139.5618056 | 1 | 0.1% |
| Other values (740) | 740 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -971.9159722 | 1 | 0.1% |
| -961.1381944 | 1 | 0.1% |
| -541.8020833 | 1 | 0.1% |
| -537.6381944 | 1 | 0.1% |
| -494.4652778 | 1 | 0.1% |
| -439.9194444 | 1 | 0.1% |
| -432.6798611 | 1 | 0.1% |
| -419.5256944 | 1 | 0.1% |
| -405.7173611 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 255.2729167 | 1 | |
| 243.8215278 | 1 | |
| 237.8340278 | 1 | |
| 237.2402778 | 1 | |
| 236.2916667 | 1 | |
| 235.7381944 | 1 | |
| 234.4993056 | 1 | |
| 229.8847222 | 1 | |
| 229.4333333 | 1 | |
| 229.2451389 | 1 |
direccion_max
Real number (ℝ)
| Distinct | 748 |
|---|---|
| Distinct (%) | 91.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.468737 |
| Minimum | -999 |
|---|---|
| Maximum | 247.76875 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 83 |
| Negative (%) | 10.1% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 138.83524 |
| median | 164.30833 |
| Q3 | 184.31927 |
| 95-th percentile | 207.90378 |
| Maximum | 247.76875 |
| Range | 1246.7687 |
| Interquartile range (IQR) | 45.484028 |
Descriptive statistics
| Standard deviation | 334.35008 |
|---|---|
| Coefficient of variation (CV) | 6.027721 |
| Kurtosis | 5.7743245 |
| Mean | 55.468737 |
| Median Absolute Deviation (MAD) | 21.998958 |
| Skewness | -2.7498711 |
| Sum | 45595.302 |
| Variance | 111789.97 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -999 | 70 | 8.5% |
| 190.1854167 | 2 | 0.2% |
| 166.6222222 | 2 | 0.2% |
| 190.9041667 | 2 | 0.2% |
| 175.7930556 | 2 | 0.2% |
| 165.4381944 | 2 | 0.2% |
| 160.3826389 | 1 | 0.1% |
| 123.975 | 1 | 0.1% |
| 159.3604167 | 1 | 0.1% |
| 102.9256944 | 1 | 0.1% |
| Other values (738) | 738 |
| Value | Count | Frequency (%) |
| -999 | 70 | |
| -971.8826389 | 1 | 0.1% |
| -962.6 | 1 | 0.1% |
| -538.9166667 | 1 | 0.1% |
| -535.5097222 | 1 | 0.1% |
| -493.7798611 | 1 | 0.1% |
| -436.2416667 | 1 | 0.1% |
| -419.0034722 | 1 | 0.1% |
| -418.1909722 | 1 | 0.1% |
| -407.3840278 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 247.76875 | 1 | |
| 235.4923611 | 1 | |
| 234.5611111 | 1 | |
| 234.1729167 | 1 | |
| 232.5166667 | 1 | |
| 232.3027778 | 1 | |
| 229.0729167 | 1 | |
| 227.2944444 | 1 | |
| 224.2944444 | 1 | |
| 223.9888889 | 1 |
Interactions
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| anio | mes | dia | pm25 | codigoserial | dia_semana | estacion | festivo | temperatura | humedad | presion | p1 | velocidad_prom | velocidad_max | direccion_prom | direccion_max | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024 | 1 | 1 | 29.125000 | 28 | Lunes | Estacion Itagui | 1 | 19.768486 | 74.873653 | -2.08125 | 0.000076 | -0.217167 | 0.594722 | 117.155556 | 134.637500 |
| 1 | 2024 | 1 | 2 | 11.833333 | 28 | Martes | Estacion Itagui | 0 | 21.919931 | 78.140549 | -0.69375 | 0.000000 | 1.477875 | 2.436250 | 100.706250 | 114.094444 |
| 2 | 2024 | 1 | 3 | 12.708333 | 28 | Miercoles | Estacion Itagui | 0 | 22.544521 | 74.049493 | 0.00000 | 0.000000 | 2.017924 | 2.903611 | 127.286806 | 144.834028 |
| 3 | 2024 | 1 | 4 | 20.750000 | 28 | Jueves | Estacion Itagui | 0 | 22.359299 | 75.344160 | 0.00000 | 0.000007 | 1.877451 | 2.795625 | 138.467361 | 153.795833 |
| 4 | 2024 | 1 | 5 | 20.083333 | 28 | Viernes | Estacion Itagui | 0 | 21.780910 | 74.736514 | 0.00000 | 0.000014 | 1.963181 | 2.901944 | 149.109722 | 166.622222 |
| 5 | 2024 | 1 | 6 | -1235.125000 | 28 | Sabado | Estacion Itagui | 0 | 18.713472 | 68.578625 | -3.46875 | 0.000000 | -1.375639 | -0.385625 | 147.477083 | 157.075000 |
| 6 | 2024 | 1 | 7 | 10.625000 | 28 | Domingo | Estacion Itagui | 0 | 22.628715 | 71.298049 | -0.69375 | 0.000000 | 1.990153 | 3.166528 | 97.115972 | 111.592361 |
| 7 | 2024 | 1 | 8 | 18.291667 | 28 | Lunes | Estacion Itagui | 1 | 22.215194 | 72.088097 | -0.69375 | 0.000028 | 1.382215 | 2.300486 | 147.705556 | 158.718056 |
| 8 | 2024 | 1 | 9 | 22.166667 | 28 | Martes | Estacion Itagui | 0 | 22.091514 | 74.693458 | -1.38750 | 0.000000 | 0.532917 | 1.480139 | 147.495833 | 161.832639 |
| 9 | 2024 | 1 | 10 | 23.166667 | 28 | Miercoles | Estacion Itagui | 0 | 23.431333 | 77.224944 | 0.00000 | 0.000028 | 2.117847 | 3.102847 | 83.515278 | 104.179861 |
| anio | mes | dia | pm25 | codigoserial | dia_semana | estacion | festivo | temperatura | humedad | presion | p1 | velocidad_prom | velocidad_max | direccion_prom | direccion_max | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 264 | 2024 | 9 | 21 | 20.305783 | 86 | Sabado | Estacion Aranjuez | 0 | 22.976944 | 66.242014 | 850.597083 | 0.000049 | 1.258472 | 2.327569 | 192.377083 | 190.800000 |
| 265 | 2024 | 9 | 22 | 13.847023 | 86 | Domingo | Estacion Aranjuez | 0 | 21.652708 | 74.050972 | 851.402153 | 0.007319 | 1.128611 | 2.042708 | 206.718056 | 206.354167 |
| 266 | 2024 | 9 | 23 | 13.956152 | 86 | Lunes | Estacion Aranjuez | 0 | 21.987014 | 71.432361 | 851.868472 | 0.004542 | 1.360000 | 2.561458 | 155.908333 | 164.988889 |
| 267 | 2024 | 9 | 24 | 41671.967458 | 86 | Martes | Estacion Aranjuez | 0 | 23.759861 | 66.039097 | 851.303889 | 0.002083 | 1.574792 | 2.940278 | 131.738194 | 140.452083 |
| 268 | 2024 | 9 | 25 | -1233.864730 | 86 | Miercoles | Estacion Aranjuez | 0 | 22.944722 | 69.628611 | 851.815278 | 0.000736 | 1.310139 | 2.432083 | 179.700000 | 176.742361 |
| 269 | 2024 | 9 | 26 | 13.609001 | 86 | Jueves | Estacion Aranjuez | 0 | 21.505069 | 70.972986 | 852.765000 | 0.002063 | 1.154514 | 2.105278 | 217.955556 | 207.927083 |
| 270 | 2024 | 9 | 27 | 27.539184 | 86 | Viernes | Estacion Aranjuez | 0 | 20.990347 | 74.835347 | 852.277986 | 0.031493 | 0.818264 | 1.513958 | 221.430556 | 218.652778 |
| 271 | 2024 | 9 | 28 | 25.955599 | 86 | Sabado | Estacion Aranjuez | 0 | 20.363889 | 76.159931 | 852.591111 | 0.004861 | 1.066597 | 1.977639 | 185.232639 | 186.740972 |
| 272 | 2024 | 9 | 29 | -402.400548 | 86 | Domingo | Estacion Aranjuez | 0 | 19.847222 | 81.325625 | 853.129514 | 0.007646 | 0.776181 | 1.437847 | 216.145139 | 209.574306 |
| 273 | 2024 | 9 | 30 | 19.186378 | 86 | Lunes | Estacion Aranjuez | 0 | 20.616806 | 78.270903 | 852.786597 | 0.000424 | 0.964792 | 1.787986 | 193.744444 | 192.262500 |